The following example searches for a
SqlShimParameter with a given
ParameterName within a
SqlShimParameterCollection<T>. If the parameter exists, the example displays the name and index of the parameter. If the parameter does not exist, the example displays an error. This example assumes that a
SqlShimParameterCollection<T> has already been created.
public void SearchExactTargetParams() {
// ...
// create ExactTargetParameterCollection myParameters
// ...
if (!myParameters.Contains("DName"))
MessageBox.Show("ERROR: no such parameter in the collection");
else
MessageBox.Show("Name: " + myParameters["DName"].ToString() +
"Index: " + myParameters.IndexOf("DName").ToString());
}
Public Sub SearchExactTargetParams()
' ...
' create ExactTargetParameterCollection myParameters
' ...
If Not myParameters.Contains("DName") Then
MessageBox.Show("ERROR: no such parameter in the collection")
Else
MessageBox.Show("Name: " & myParameters("DName").ToString() & _
"Index: " & myParameters.IndexOf("DName").ToString())
End If
End Sub